{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Lookup lists","CC"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":7,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Lookup lists","index":0,"n_rows":260,"n_cols":8,"rows_kept":260,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Rating",null,"Municipal List 2012",null,"Financial Year",null,"Type"]
[null,null,null,"Please select from list"]
[null,"-",null,"BUF Buffalo City",null,"2010/11",null,"Draft"]
[null,1,null,"CPT Cape Town",null,"2011/12",null,"Adopted"]
[null,2,null,"DC1 West Coast",null,"2012/13"]
[null,3,null,"DC10 Sarah Baartman",null,"2013/14"]
[null,null,null,"DC12 Amathole",null,"2014/15"]
[null,null,null,"DC13 Chris Hani",null,"2015/16"]
[null,"Selection",null,"DC14 Joe Gqabi",null,"2016/17"]
[null,null,null,"DC15 O .R. Tambo",null,"2017/18"]
[null,"Yes",null,"DC16 Xhariep",null,"2018/19"]
[null,"No",null,"DC18 Lejweleputswa",null,"2019/20"]
[null,"N/A",null,"DC19 Thabo Mofutsanyana",null,"2020/21"]
[null,null,null,"DC2 Cape Winelands DM",null,"2021/22"]
[null,null,null,"DC20 Fezile Dabi",null,"2022/23"]
[null,"Verification",null,"DC21 Ugu",null,"2023/24"]
[null,null,null,"DC22 uMgungundlovu",null,"2024/25"]
[null,"Yes",null,"DC23 Uthukela",null,"2025/26"]
[null,"No",null,"DC24 Umzinyathi",null,"2026/27"]
[null,"Unable to verify",null,"DC25 Amajuba",null,"2027/28"]
[null,null,null,"DC26 Zululand",null,"2028/29"]
[null,null,null,"DC27 Umkhanyakude",null,"2029/30"]
[null,null,null,"DC28 King Cetshwayo",null,"2030/31"]
[null,null,null,"DC29 iLembe"]
[null,null,null,"DC3 Overberg"]
[null,null,null,"DC30 Gert Sibande"]
[null,null,null,"DC31 Nkangala"]
[null,null,null,"DC32 Ehlanzeni"]
[null,null,null,"DC33 Mopani"]
[null,null,null,"DC34 Vhembe"]
[null,null,null,"DC35 Capricorn"]
[null,null,null,"DC36 Waterberg"]
[null,null,null,"DC37 Bojanala Platinum"]
[null,null,null,"DC38 Ngaka Modiri Molema"]
[null,null,null,"DC39 Dr Ruth Segomotsi Mompati"]
[null,null,null,"DC4 Eden"]
[null,null,null,"DC40 Dr Kenneth Kaunda"]
[null,null,null,"DC42 Sedibeng"]
[null,null,null,"DC43 Harry Gwala"]
[null,null,null,"DC44 Alfred Nzo"]
[null,null,null,"DC45 John Taolo Gaetsewe"]
[null,null,null,"DC47 Sekhukhune"]
[null,null,null,"DC48 West Rand"]
[null,null,null,"DC5 Central Karoo"]
[null,null,null,"DC6 Namakwa"]
[null,null,null,"DC7 Pixley Ka Seme (Nc)"]
[null,null,null,"DC8 Z F Mgcawu"]
[null,null,null,"DC9 Frances Baard"]
[null,null,null,"EC101 Dr. Beyers Naude"]
[null,null,null,"EC102 Blue Crane Route"]
[null,null,null,"EC104 Makana"]
[null,null,null,"EC105 Ndlambe"]
[null,null,null,"EC106 Sundays River Valley"]
[null,null,null,"EC108 Kouga"]
[null,null,null,"EC109 Kou-Kamma"]
[null,null,null,"EC121 Mbhashe"]
[null,null,null,"EC122 Mnquma"]
[null,null,null,"EC123 Great Kei"]
[null,null,null,"EC124 Amahlathi"]
[null,null,null,"EC126 Ngqushwa"]
[null,null,null,"EC129 Raymond Mhlaba"]
[null,null,null,"EC131 Inxuba Yethemba"]
[null,null,null,"EC135 Intsika Yethu"]
[null,null,null,"EC136 Emalahleni (Ec)"]
[null,null,null,"EC137 Engcobo"]
[null,null,null,"EC138 Sakhisizwe"]
[null,null,null,"EC139 Enoch Mgijima"]
[null,null,null,"EC141 Elundini"]
[null,null,null,"EC142 Senqu"]
[null,null,null,"EC145 Walter Sisulu"]
[null,null,null,"EC153 Ngquza Hills"]
[null,null,null,"EC154 Port St Johns"]
[null,null,null,"EC155 Nyandeni"]
[null,null,null,"EC156 Mhlontlo"]
[null,null,null,"EC157 King Sabata Dalindyebo"]
[null,null,null,"EC441 Matatiele"]
[null,null,null,"EC442 Umzimvubu"]
[null,null,null,"EC443 Mbizana"]
[null,null,null,"EC444 Ntabankulu"]
[null,null,null,"EKU Ekurhuleni Metro"]
[null,null,null,"ETH eThekwini"]
[null,null,null,"FS161 Letsemeng"]
[null,null,null,"FS162 Kopanong"]
[null,null,null,"FS163 Mohokare"]
[null,null,null,"FS181 Masilonyana"]
[null,null,null,"FS182 Tokologo"]
[null,null,null,"FS183 Tswelopele"]
[null,null,null,"FS184 Matjhabeng"]
[null,null,null,"FS185 Nala"]
[null,null,null,"FS191 Setsoto"]
[null,null,null,"FS192 Dihlabeng"]
[null,null,null,"FS193 Nketoana"]
[null,null,null,"FS194 Maluti-a-Phofung"]
[null,null,null,"FS195 Phumelela"]
[null,null,null,"FS196 Mantsopa"]
[null,null,null,"FS201 Moqhaka"]
[null,null,null,"FS203 Ngwathe"]
[null,null,null,"FS204 Metsimaholo"]
[null,null,null,"FS205 Mafube"]
[null,null,null,"GT421 Emfuleni"]
[null,null,null,"GT422 Midvaal"]
[null,null,null,"GT423 Lesedi"]
[null,null,null,"GT481 Mogale City"]
[null,null,null,"GT484 Merafong City"]
[null,null,null,"GT485 Rand West City"]
[null,null,null,"JHB City Of Johannesburg"]
[null,null,null,"KZN212 Umdoni"]
[null,null,null,"KZN213 Umzumbe"]
[null,null,null,"KZN214 uMuziwabantu"]
[null,null,null,"KZN216 Ray Nkonyeni"]
[null,null,null,"KZN221 uMshwathi"]
[null,null,null,"KZN222 uMngeni"]
[null,null,null,"KZN223 Mpofana"]
[null,null,null,"KZN224 Impendle"]
[null,null,null,"KZN225 Msunduzi"]
[null,null,null,"KZN226 Mkhambathini"]
[null,null,null,"KZN227 Richmond"]
[null,null,null,"KZN235 Okhahlamba"]
[null,null,null,"KZN237 Inkosi Langalibalele"]
[null,null,null,"KZN238 Alfred Duma"]
[null,null,null,"KZN241 Endumeni"]
[null,null,null,"KZN242 Nquthu"]
[null,null,null,"KZN244 Msinga"]
[null,null,null,"KZN245 Umvoti"]
[null,null,null,"KZN252 Newcastle"]
[null,null,null,"KZN253 eMadlangeni"]
[null,null,null,"KZN254 Dannhauser"]
[null,null,null,"KZN261 eDumbe"]
[null,null,null,"KZN262 uPhongolo"]
[null,null,null,"KZN263 Abaqulusi"]
[null,null,null,"KZN265 Nongoma"]
[null,null,null,"KZN266 Ulundi"]
[null,null,null,"KZN271 Umhlabuyalingana"]
[null,null,null,"KZN272 Jozini"]
[null,null,null,"KZN275 Mtubatuba"]
[null,null,null,"KZN276 The New Big 5 False Bay"]
[null,null,null,"KZN281 Mfolozi"]
[null,null,null,"KZN282 uMhlathuze"]
[null,null,null,"KZN284 uMlalazi"]
[null,null,null,"KZN285 Mthonjaneni"]
[null,null,null,"KZN286 Nkandla"]
[null,null,null,"KZN291 Mandeni"]
[null,null,null,"KZN292 KwaDukuza"]
[null,null,null,"KZN293 Ndwedwe"]
[null,null,null,"KZN294 Maphumulo"]
[null,null,null,"KZN433 Greater Kokstad"]
[null,null,null,"KZN434 Ubuhlebezwe"]
[null,null,null,"KZN435 Umzimkhulu"]
[null,null,null,"KZN436 Dr Nkosazana Dlamini Zuma"]
[null,null,null,"LIM331 Greater Giyani"]
[null,null,null,"LIM332 Greater Letaba"]
[null,null,null,"LIM333 Greater Tzaneen"]
[null,null,null,"LIM334 Ba-Phalaborwa"]
[null,null,null,"LIM335 Maruleng"]
[null,null,null,"LIM341 Musina"]
[null,null,null,"LIM343 Thulamela"]
[null,null,null,"LIM344 Makhado"]
[null,null,null,"LIM345 Collins Chabane"]
[null,null,null,"LIM351 Blouberg"]
[null,null,null,"LIM353 Molemole"]
[null,null,null,"LIM354 Polokwane"]
[null,null,null,"LIM355 Lepelle-Nkumpi"]
[null,null,null,"LIM361 Thabazimbi"]
[null,null,null,"LIM362 Lephalale"]
[null,null,null,"LIM366 Bela Bela"]
[null,null,null,"LIM367 Mogalakwena"]
[null,null,null,"LIM368 Modimolle-Mookgopong"]
[null,null,null,"LIM471 Ephraim Mogale"]
[null,null,null,"LIM472 Elias Motsoaledi"]
[null,null,null,"LIM473 Makhuduthamaga"]
[null,null,null,"LIM476 Tubatse Fetakgomo"]
[null,null,null,"MAN Mangaung"]
[null,null,null,"MP301 Albert Luthuli"]
[null,null,null,"MP302 Msukaligwa"]
[null,null,null,"MP303 Mkhondo"]
[null,null,null,"MP304 Pixley Ka Seme (MP)"]
[null,null,null,"MP305 Lekwa"]
[null,null,null,"MP306 Dipaleseng"]
[null,null,null,"MP307 Govan Mbeki"]
[null,null,null,"MP311 Victor Khanye"]
[null,null,null,"MP312 Emalahleni (Mp)"]
[null,null,null,"MP313 Steve Tshwete"]
[null,null,null,"MP314 Emakhazeni"]
[null,null,null,"MP315 Thembisile Hani"]
[null,null,null,"MP316 Dr J.S. Moroka"]
[null,null,null,"MP321 Thaba Chweu"]
[null,null,null,"MP324 Nkomazi"]
[null,null,null,"MP325 Bushbuckridge"]
[null,null,null,"MP326 City of Mbombela"]
[null,null,null,"NC061 Richtersveld"]
[null,null,null,"NC062 Nama Khoi"]
[null,null,null,"NC064 Kamiesberg"]
[null,null,null,"NC065 Hantam"]
[null,null,null,"NC066 Karoo Hoogland"]
[null,null,null,"NC067 Khai-Ma"]
[null,null,null,"NC071 Ubuntu"]
[null,null,null,"NC072 Umsobomvu"]
[null,null,null,"NC073 Emthanjeni"]
[null,null,null,"NC074 Kareeberg"]
[null,null,null,"NC075 Renosterberg"]
[null,null,null,"NC076 Thembelihle"]
[null,null,null,"NC077 Siyathemba"]
[null,null,null,"NC078 Siyancuma"]
[null,null,null,"NC082 !Kai! Garib"]
[null,null,null,"NC084 !Kheis"]
[null,null,null,"NC085 Tsantsabane"]
[null,null,null,"NC086 Kgatelopele"]
[null,null,null,"NC087 Dawid Kruiper"]
[null,null,null,"NC091 Sol Plaatje"]
[null,null,null,"NC092 Dikgatlong"]
[null,null,null,"NC093 Magareng"]
[null,null,null,"NC094 Phokwane"]
[null,null,null,"NC451 Joe Morolong"]
[null,null,null,"NC452 Ga-Segonyana"]
[null,null,null,"NC453 Gamagara"]
[null,null,null,"NMA Nelson Mandela Bay"]
[null,null,null,"NW371 Moretele"]
[null,null,null,"NW372 Madibeng"]
[null,null,null,"NW373 Rustenburg"]
[null,null,null,"NW374 Kgetlengrivier"]
[null,null,null,"NW375 Moses Kotane"]
[null,null,null,"NW381 Ratlou"]
[null,null,null,"NW382 Tswaing"]
[null,null,null,"NW383 Mafikeng"]
[null,null,null,"NW384 Ditsobotla"]
[null,null,null,"NW385 Ramotshere Moiloa"]
[null,null,null,"NW392 Naledi (Nw)"]
[null,null,null,"NW393 Mamusa"]
[null,null,null,"NW394 Greater Taung"]
[null,null,null,"NW396 Lekwa-Teemane"]
[null,null,null,"NW397 Kagisano-Molopo"]
[null,null,null,"NW403 City Of Matlosana"]
[null,null,null,"NW404 Maquassi Hills"]
[null,null,null,"NW405 J B Marks"]
[null,null,null,"TSH City Of Tshwane"]
[null,null,null,"WC011 Matzikama"]
[null,null,null,"WC012 Cederberg"]
[null,null,null,"WC013 Bergrivier"]
[null,null,null,"WC014 Saldanha Bay"]
[null,null,null,"WC015 Swartland"]
[null,null,null,"WC022 Witzenberg"]
[null,null,null,"WC023 Drakenstein"]
[null,null,null,"WC024 Stellenbosch"]
[null,null,null,"WC025 Breede Valley"]
[null,null,null,"WC026 Langeberg"]
[null,null,null,"WC031 Theewaterskloof"]
[null,null,null,"WC032 Overstrand"]
[null,null,null,"WC033 Cape Agulhas"]
[null,null,null,"WC034 Swellendam"]
[null,null,null,"WC041 Kannaland"]
[null,null,null,"WC042 Hessequa"]
[null,null,null,"WC043 Mossel Bay"]
[null,null,null,"WC044 George"]
[null,null,null,"WC045 Oudtshoorn"]
[null,null,null,"WC047 Bitou"]
[null,null,null,"WC048 Knysna"]
[null,null,null,"WC051 Laingsburg"]
[null,null,null,"WC052 Prince Albert"]
[null,null,null,"WC053 Beaufort West"]

{"sheet":"CC","index":1,"n_rows":112,"n_cols":23,"rows_kept":112,"cut":false,"hidden":false,"merged":[[110,3,110,4],[1,2,1,16],[2,8,2,16],[106,3,106,4],[107,3,107,4],[108,3,108,4],[109,3,109,4]]}
[]
[null,null,{"$f":"CONCATENATE(D3,\" \",E3,\" Medium Term Revenue and Expenditure Framework - Checklist of Compliance to Municipal Budget and Reporting Regulations (Government Gazette 32141)\")","v":"2018/19 Draft Medium Term Revenue and Expenditure Framework - Checklist of Compliance to Municipal Budget and Reporting Regulations (Government Gazette 32141)"}]
[null,null,"Please select from list","2018/19","Draft","Hard copy",null,null,"Verification/Reconciliation of Electronic Submission to Budget Tables Included in Budget Report and Document"]
[null,null,"Main Compliance Component","Sub Component/\nExplanation","Ref.","Assessment",null,"Description/ Rating ","Audited Actual Current Year -3","Audited Actual Current Year -2","Audited Actual Current Year -1","Original Budget","Adjusted Budget","Full Year Forecast","Budget Year 0","Budget Year +1","Budget Year +2 "]
[null,"0100","Procedural compliance",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Weight","Score","Max score","Scaling","Notes","Budget evaluated"]
[null,"0105","Draft MTREF Tabled 90 days prior to new financial year","Verify that the budget was tabled by 31 March","MFMA s. 16(2)",null,null,{"$f":"IF(F6=\"Yes\",\"Compliant\",IF(F6=\"No\",\"Not compliant\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,3.7499999999999999E-2,{"$f":"IF(F6=\"Yes\",1,IF(F6=\"No\",0,\"\"))","v":""},1,{"$f":"IF(ISERROR(S6*R6)*100, 0, (S6*R6)*100)","v":0},null,"Hard copy"]
[null,"0106","Grant Budget (SA18)  is aligned to DoRA","Verify if the grant allocations reconcile to DoRA","MFMA s. 21(2)(c)",null,null,{"$f":"IF(F7=\"Yes\",\"Compliant\",IF(F7=\"No\",\"Not compliant\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,3.7499999999999999E-2,{"$f":"IF(F7=\"Yes\",1,IF(F7=\"No\",0,\"\"))","v":""},1,{"$f":"IF(ISERROR(S7*R7)*100, 0, (S7*R7)*100)","v":0},null,"Electronic copy"]
[null,"0107","Correct version of Schedule A1","Verify electronic submission version","MBRR r. 9",null,null,"",null,null,null,null,null,null,null,null,null,3.7499999999999999E-2,{"$f":"IF(F8=\"Yes\",1,IF(F8=\"No\",0,\"\"))","v":""},1,{"$f":"IF(ISERROR(S8*R8)*100, 0, (S8*R8)*100)","v":0},null,"Combination hard and elec"]
[null,"0108","Table of Contents","Verification of inclusion in budget report/document","MBRR (Schedule A) r. 2",null,null,"",null,null,null,null,null,null,null,null,null,3.7499999999999999E-2,{"$f":"IF(F9=\"Yes\",1,IF(F9=\"No\",0,\"\"))","v":""},1,{"$f":"IF(ISERROR(S9*R9)*100, 0, (S9*R9)*100)","v":0}]
[null,"0200","Annual Budget",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R6:R9)","v":0.15},{"$f":"SUM(S6:S9)","v":0},{"$f":"SUM(T6:T9)","v":4},0]
[null,"0205","Mayors Report","Verification of inclusion in budget report/document","MBRR (Schedule A) r. 3",null,null,{"$f":"IF(F11=\"Yes\",\"Complete\",IF(F11=\"No\",\"Not presented\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,1.6666666666666666E-2,{"$f":"IF(F11=\"Yes\",1,IF(F11=\"No\",0,\"\"))","v":""},1,{"$f":"IF(ISERROR(S11*R11)*100, 0, (S11*R11)*100)","v":0}]
[null,"0206","Resolutions","Verification of inclusion in budget report/document","MBRR (Schedule A) r. 4",null,null,{"$f":"IF(F12=\"Yes\",\"Complete\",IF(F12=\"No\",\"Not presented\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,1.6666666666666666E-2,{"$f":"IF(F12=\"Yes\",1,IF(F12=\"No\",0,\"\"))","v":""},1,{"$f":"IF(ISERROR(S12*R12)*100, 0, (S12*R12)*100)","v":0}]
[null,"0207","Executive Summary","Verification of inclusion in budget report/document","MBRR (Schedule A) r. 5",null,null,{"$f":"IF(F13=\"Yes\",\"Complete\",IF(F13=\"No\",\"Not presented\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,1.6666666666666666E-2,{"$f":"IF(F13=\"Yes\",1,IF(F13=\"No\",0,\"\"))","v":""},1,{"$f":"IF(ISERROR(S13*R13)*100, 0, (S13*R13)*100)","v":0}]
[null,"0300","Annual Budget Tables A1 to A10: No Municipal Entities",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R11:R13)","v":0.05},{"$f":"SUM(S11:S13)","v":0},{"$f":"SUM(T11:T13)","v":3},{"$f":"SUM(U11:U13)","v":0}]
[null,"0305","Table A1: Budget Summary","Rate completeness of table on scale from 0 to 3","MBRR (Schedule A) r. 6",null,null,{"$f":"IF(F15=3,\"Fully completed\",IF(F15=2,\"Substantially completed with missing information\",IF(F15=1,\"Presented but with numerous information gaps\",IF(F15=\"-\",\"Not presented\",\"\"))))","v":""},null,null,null,null,null,null,null,null,null,0.04,{"$f":"F15","v":0},3,{"$f":"IF(ISERROR(S15*R15)*100, 0, (S15*R15)*100)","v":0}]
[null,"0306","Table A2: Budgeted Financial Performance (Revenue and Expenditure by standard classification)","Rate completeness of table on scale from 0 to 3","MBRR (Schedule A) r. 6",null,null,"",null,null,null,null,null,null,null,null,null,0.04,0,3,0]
[null,"0307","Table A3: Budgeted Financial Performance (Revenue and Expenditure by municipal vote)","Rate completeness of table on scale from 0 to 3","MBRR (Schedule A) r. 6",null,null,"",null,null,null,null,null,null,null,null,null,0.04,0,3,0]
[null,"0308","Table A4: Budgeted Financial Performance (Revenue and Expenditure)","Rate completeness of table on scale from 0 to 3","MBRR (Schedule A) r. 6",null,null,"",null,null,null,null,null,null,null,null,null,0.04,0,3,0]
[null,"0309","Table A5: Budgeted Capital Expenditure by Vote, Standard Classification & Funding Source)","Rate completeness of table on scale from 0 to 3","MBRR (Schedule A) r. 6",null,null,"",null,null,null,null,null,null,null,null,null,0.04,0,3,0]
[null,"0310","Table A6: Budgeted Financial Position ","Rate completeness of table on scale from 0 to 3","MBRR (Schedule A) r. 6",null,null,"",null,null,null,null,null,null,null,null,null,0.04,0,3,0]
[null,"0311","Table A7: Budgeted Cash Flow","Rate completeness of table on scale from 0 to 3","MBRR (Schedule A) r. 6",null,null,"",null,null,null,null,null,null,null,null,null,0.04,0,3,0]
[null,"0312","Table A8: Cash backed reserves/accumulated surplus reconciliation","Rate completeness of table on scale from 0 to 3","MBRR (Schedule A) r. 6",null,null,"",null,null,null,null,null,null,null,null,null,0.04,0,3,0]
[null,"0313","Table A9: Asset Management","Rate completeness of table on scale from 0 to 3","MBRR (Schedule A) r. 6",null,null,"",null,null,null,null,null,null,null,null,null,0.04,0,3,0]
[null,"0314","Table A10: Basic service delivery measurement","Rate completeness of table on scale from 0 to 3","MBRR (Schedule A) r. 6",null,null,"",null,null,null,null,null,null,null,null,null,0.04,0,3,0]
[null,"0400","Supporting Documentation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R15:R24)","v":0.39999999999999997},{"$f":"SUM(S15:S24)","v":0},{"$f":"SUM(T15:T24)","v":30},{"$f":"SUM(U15:U24)","v":0}]
[null,"0405","Overview of Budget Process","Is there a paragraph/section included on this aspect","MBRR (Schedule A) r. 10",null,null,{"$f":"IF(F26=\"Yes\",\"Complete\",IF(F26=\"No\",\"Not presented\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,3.3333333333333333E-2,{"$f":"IF(F26=\"Yes\",1,IF(F26=\"No\",0,\"\"))","v":""},1,0]
[null,"0406","Overview of alignment of annual budget with IDP","Is there a paragraph/section included on this aspect","MBRR (Schedule A) r. 11",null,null,"",null,null,null,null,null,null,null,null,null,3.3333333333333333E-2,{"$f":"IF(F27=\"Yes\",1,IF(F27=\"No\",0,\"\"))","v":""},1,0]
[null,"0407","Measurable performance objectives and indicators","Is there a paragraph/section included on this aspect","MBRR (Schedule A) r. 12",null,null,"",null,null,null,null,null,null,null,null,null,3.3333333333333333E-2,{"$f":"IF(F28=\"Yes\",1,IF(F28=\"No\",0,\"\"))","v":""},1,0]
[null,"0500","Budget Related Policies","Is there a paragraph/section included on this aspect","MBRR (Schedule A) r. 15",null,"Date of revision",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R26:R28)","v":0.1},{"$f":"SUM(S26:S28)","v":0},{"$f":"SUM(T26:T28)","v":3},0]
[null,"0505","Tariff Policy on Property Rates","Must be included if service is rendered","MBRR r. 7 (footnote 1)",null,null,"",null,null,null,null,null,null,null,null,null,6.2500000000000003E-3,{"$f":"IF(F30=\"Yes\",1,IF(F30=\"No\",0,\"\"))","v":""},1,0,"DCs automatically excluded"]
[null,"0506","Tariff Policy on Electricity","Must be included if service is rendered","MBRR r. 7 (footnote 1)",null,null,"",null,null,null,null,null,null,null,null,null,6.2500000000000003E-3,"",1,0,"DCs automatically excluded"]
[null,"0507","Tariff Policy on Water","Must be included if service is rendered","MBRR r. 7 (footnote 1)",null,null,"",null,null,null,null,null,null,null,null,null,6.2500000000000003E-3,"",1,0,"DCs automatically excluded"]
[null,"0508","Tariff Policy on Sanitation","Must be included if service is rendered","MBRR r. 7 (footnote 1)",null,null,"",null,null,null,null,null,null,null,null,null,6.2500000000000003E-3,"",1,0,"DCs automatically excluded"]
[null,"0509","Tariff Policy on Refuse Removal/Solid Waste","Must be included if service is rendered","MBRR r. 7 (footnote 1)",null,null,"",null,null,null,null,null,null,null,null,null,6.2500000000000003E-3,"",1,0,"DCs automatically excluded"]
[null,"0510","Municipal Property Rates Policy","As informed by the Municipal Property Rates Act","MBRR r. 7 (footnote 1)",null,null,"",null,null,null,null,null,null,null,null,null,6.2500000000000003E-3,"",1,0,"DCs automatically excluded"]
[null,"0511","Credit Control and Debt Collection Policy","If  not included, verify reference given","MBRR r. 7 (footnote 1)",null,null,"",null,null,null,null,null,null,null,null,null,6.2500000000000003E-3,"",1,0,"no explicit need to include"]
[null,"0512","Cash Management and Investment Policy","If  not included, verify reference given","MBRR r. 7 (footnote 1)",null,null,"",null,null,null,null,null,null,null,null,null,6.2500000000000003E-3,"",1,0,"no explicit need to include"]
[null,"0513","Borrowing Policy","If  not included, verify reference given","MBRR r. 7 (footnote 1)",null,null,"",null,null,null,null,null,null,null,null,null,6.2500000000000003E-3,"",1,0,"no explicit need to include"]
[null,"0514","Funding and Reserves Policy","If  not included, verify reference given","MBRR r. 7 (footnote 1)",null,null,"",null,null,null,null,null,null,null,null,null,6.2500000000000003E-3,"",1,0,"no explicit need to include"]
[null,"0515","Policy related to long-term financial planning","If  not included, verify reference given","MBRR r. 7 (footnote 1)",null,null,"",null,null,null,null,null,null,null,null,null,6.2500000000000003E-3,"",1,0,"no explicit need to include"]
[null,"0516","Supply Chain Management Policy","If  not included, verify reference given","MBRR r. 7 (footnote 1)",null,null,"",null,null,null,null,null,null,null,null,null,6.2500000000000003E-3,"",1,0,"no explicit need to include"]
[null,"0517","Policy related to the Management and Disposal of Assets","If  not included, verify reference given","MBRR r. 7 (footnote 1)",null,null,"",null,null,null,null,null,null,null,null,null,6.2500000000000003E-3,"",1,0,"no explicit need to include"]
[null,"0518","Policy relating to dealing with infrastructure investment and capital projects","If  not included, verify reference given","MBRR r. 7 (footnote 1)",null,null,"",null,null,null,null,null,null,null,null,null,6.2500000000000003E-3,"",1,0,"no explicit need to include"]
[null,"0519","Indigents Policy","If  not included, verify reference given","MBRR r. 7 (footnote 1)",null,null,"",null,null,null,null,null,null,null,null,null,6.2500000000000003E-3,"",1,0,"no explicit need to include"]
[null,"0520","Budget Implementation and Management Policy","If  not included, verify reference given","MBRR r. 7 (footnote 1)",null,null,"",null,null,null,null,null,null,null,null,null,6.2500000000000003E-3,"",1,0,"no explicit need to include"]
[null,"0600","Supporting Documentation contd…",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R30:R45)","v":0.10000000000000002},{"$f":"SUM(S30:S45)","v":0},{"$f":"SUM(T30:T45)","v":16},{"$f":"SUM(U30:U45)","v":0}]
[null,"0605","Budget Assumptions","Is there a paragraph/section included on this aspect","MBRR (Schedule A) r. 16",null,null,"",null,null,null,null,null,null,null,null,null,7.6923076923076927E-3,{"$f":"IF(F47=\"Yes\",1,IF(F47=\"No\",0,\"\"))","v":""},1,0]
[null,"0606","Overview of Budget Funding including funding compliance (Table SA10)","Is there a paragraph/section included on this aspect","MBRR (Schedule A) r. 17",null,null,"",null,null,null,null,null,null,null,null,null,7.6923076923076927E-3,"",1,0]
[null,"0607","Expenditure on grant allocations and grant programmes","Is there a paragraph/section included on this aspect","MBRR (Schedule A) r. 18",null,null,"",null,null,null,null,null,null,null,null,null,7.6923076923076927E-3,"",1,0]
[null,"0608","Allocations on grants made by the municipality","Is there a paragraph/section included on this aspect","MBRR (Schedule A) r. 19",null,null,"",null,null,null,null,null,null,null,null,null,7.6923076923076927E-3,"",1,0]
[null,"0609","Councillor and board member allowances and employee benefits","Is there a paragraph/section included on this aspect","MBRR (Schedule A) r. 20",null,null,"",null,null,null,null,null,null,null,null,null,7.6923076923076927E-3,"",1,0]
[null,"0610","Monthly targets for revenue, expenditure and cash flow","Is there a paragraph/section included on this aspect","MBRR (Schedule A) r. 21",null,null,"",null,null,null,null,null,null,null,null,null,7.6923076923076927E-3,"",1,0]
[null,"0611","Draft Service Delivery and Budget Implementation Plans (SDBIP)","Verification of inclusion in budget report/document","MBRR (Schedule A) r. 22",null,null,"",null,null,null,null,null,null,null,null,null,7.6923076923076927E-3,"",1,0]
[null,"0612","Service Delivery Agreements of Municipal Entities (if applicable)","Verification of inclusion in budget report/document","MBRR (Schedule A) r. 25",null,null,"",null,null,null,null,null,null,null,null,null,7.6923076923076927E-3,"",1,0,"entities only"]
[null,"0613","Annual budgets of municipal entities (D Schedule)","Verification of inclusion in budget report/document","MBRR (Schedule A) r. 25",null,null,"",null,null,null,null,null,null,null,null,null,7.6923076923076927E-3,"",1,0,"entities only"]
[null,"0614","Contracts having future budgetary implications","Is there a paragraph/section included on this aspect","MBRR (Schedule A) r. 26",null,null,"",null,null,null,null,null,null,null,null,null,7.6923076923076927E-3,"",1,0]
[null,"0615","Capital expenditure details","Is there a paragraph/section included on this aspect","MBRR (Schedule A) r. 27",null,null,"",null,null,null,null,null,null,null,null,null,7.6923076923076927E-3,"",1,0]
[null,"0616","Legislation Compliance Status","Is there a paragraph/section included on this aspect","MBRR (Schedule A) r. 28",null,null,"",null,null,null,null,null,null,null,null,null,7.6923076923076927E-3,{"$f":"IF(F58=\"Yes\",1,IF(F58=\"No\",0,\"\"))","v":""},2,{"$f":"IF(ISERROR(S58*R58)*100, 0, (S58*R58)*100)","v":0}]
[null,"0617","Quality Certificate (signed)","Verification of inclusion in budget report/document","MBRR (Schedule A) r. 31",null,null,"",null,null,null,null,null,null,null,null,null,7.6923076923076927E-3,{"$f":"IF(F59=\"Yes\",1,IF(F59=\"No\",0,\"\"))","v":""},3,{"$f":"IF(ISERROR(S59*R59)*100, 0, (S59*R59)*100)","v":0}]
[null,"0700","Supporting Tables SA1 to SA37",null,null,null,null,{"$f":"IF(F60=3,\"Fully completed\",IF(F60=2,\"Substantially completed with missing information\",IF(F60=1,\"Presented but with numerous information gaps\",IF(F60=\"-\",\"Not presented\",\"\"))))","v":""},null,null,null,null,null,null,null,null,null,{"$f":"SUM(R47:R59)","v":0.1},{"$f":"SUM(S47:S59)","v":0},{"$f":"SUM(T47:T59)","v":16},0]
[null,"0705","SA1: Supporting Detail to Budgeted Financial Performance","Rate completeness of table on scale from 0 to 3","MBRR (Schedule A) r. 29",null,null,""]
[null,"0706","SA2: Matrix Financial Performance Budget (revenue source/expenditure type and dept)","Rate completeness of table on scale from 0 to 3","MBRR (Schedule A) r. 29",null,null,"",null,null,null,null,null,null,null,null,null,{"$f":"(10/41/100)","v":2.4390243902439024E-3},{"$f":"F62","v":0},3,{"$f":"IF(ISERROR((S62*R62)*100), 0, ((S62*R62)*100))","v":0}]
[null,"0707","SA3: Supporting detail to Budgeted Financial Position","Rate completeness of table on scale from 0 to 3","MBRR (Schedule A) r. 29",null,null,"",null,null,null,null,null,null,null,null,null,2.4390243902439024E-3,0,3,0]
[null,"0708","SA4: Reconciliation of IDP, Strategic Objectives and Budget (Revenue)","Rate completeness of table on scale from 0 to 3","MBRR (Schedule A) r. 29",null,null,"",null,null,null,null,null,null,null,null,null,2.4390243902439024E-3,0,3,0]
[null,"0709","SA5: Reconciliation of IDP, Strategic Objectives and Budget (Operating Expenditure)","Rate completeness of table on scale from 0 to 3","MBRR (Schedule A) r. 29",null,null,"",null,null,null,null,null,null,null,null,null,2.4390243902439024E-3,0,3,0]
[null,"0710","SA6: Reconciliation of IDP, Strategic Objectives and Budget (Capital Expenditure)","Rate completeness of table on scale from 0 to 3","MBRR (Schedule A) r. 29",null,null,"",null,null,null,null,null,null,null,null,null,2.4390243902439024E-3,0,3,0,"locked"]
[null,"0711","SA7: Measurable Performance Objectives","Rate completeness of table on scale from 0 to 3","MBRR (Schedule A) r. 29",null,null,"",null,null,null,null,null,null,null,null,null,2.4390243902439024E-3,0,3,0]
[null,"0712","SA8: Performance Indicators and Benchmarks","Rate completeness of table on scale from 0 to 3","MBRR (Schedule A) r. 29",null,null,"",null,null,null,null,null,null,null,null,null,2.4390243902439024E-3,0,3,0,"locked"]
[null,"0713","SA9: Social, Economic and Demographic Statistics and Assumptions","Rate completeness of table on scale from 0 to 3","MBRR (Schedule A) r. 29",null,null,"",null,null,null,null,null,null,null,null,null,2.4390243902439024E-3,0,3,0]
[null,"0714","SA10: Funding Measurement","Rate completeness of table on scale from 0 to 3","MBRR (Schedule A) r. 29",null,null,"",null,null,null,null,null,null,null,null,null,2.4390243902439024E-3,0,3,0,"locked"]
[null,"0715","SA11: Property Rates Summary","Rate completeness of table on scale from 0 to 3","MBRR (Schedule A) r. 29",null,null,"",null,null,null,null,null,null,null,null,null,2.4390243902439024E-3,0,3,0,"locked"]
[null,"0716","SA12a: Property Rates by category (current year)","Rate completeness of table on scale from 0 to 3","MBRR (Schedule A) r. 29",null,null,"",null,null,null,null,null,null,null,null,null,2.4390243902439024E-3,0,3,0,"locked"]
[null,"0717","SA12b: Property Rates  by category (budget year)","Rate completeness of table on scale from 0 to 3","MBRR (Schedule A) r. 29",null,null,"",null,null,null,null,null,null,null,null,null,2.4390243902439024E-3,0,3,0]
[null,"0718","SA13a: Service Tariffs by Category","Rate completeness of table on scale from 0 to 3","MBRR (Schedule A) r. 29",null,null,"",null,null,null,null,null,null,null,null,null,2.4390243902439024E-3,{"$f":"F74","v":0},3,0,"locked"]
[null,"0719","SA13b: Service Tariffs by Category (explanatory)","Rate completeness of table on scale from 0 to 3","MBRR (Schedule A) r. 29",null,null,"",null,null,null,null,null,null,null,null,null,2.4390243902439024E-3,{"$f":"F75","v":0},3,0]
[null,"0720","SA14: Household Bills","Rate completeness of table on scale from 0 to 3","MBRR (Schedule A) r. 29",null,null,"",null,null,null,null,null,null,null,null,null,2.4390243902439024E-3,0,3,0]
[null,"0721","SA15: Investment Particulars by Type","Rate completeness of table on scale from 0 to 3","MBRR (Schedule A) r. 29",null,null,"",null,null,null,null,null,null,null,null,null,2.4390243902439024E-3,0,3,0]
[null,"0722","SA16: Investment Particulars by Type","Rate completeness of table on scale from 0 to 3","MBRR (Schedule A) r. 29",null,null,"",null,null,null,null,null,null,null,null,null,2.4390243902439024E-3,0,3,0]
[null,"0723","SA17: Borrowing","Rate completeness of table on scale from 0 to 3","MBRR (Schedule A) r. 29",null,null,"",null,null,null,null,null,null,null,null,null,2.4390243902439024E-3,0,3,0]
[null,"0724","SA18: Transfers and Grant Receipts","Rate completeness of table on scale from 0 to 3","MBRR (Schedule A) r. 29",null,null,"",null,null,null,null,null,null,null,null,null,2.4390243902439024E-3,0,3,0]
[null,"0725","SA19: Expenditure on Transfers and Grant Programme","Rate completeness of table on scale from 0 to 3","MBRR (Schedule A) r. 29",null,null,"",null,null,null,null,null,null,null,null,null,2.4390243902439024E-3,0,3,0]
[null,"0726","SA20: Reconciliation of Transfers, Grant Receipts and Unspent Funds","Rate completeness of table on scale from 0 to 3","MBRR (Schedule A) r. 29",null,null,"",null,null,null,null,null,null,null,null,null,2.4390243902439024E-3,0,3,0,"locked"]
[null,"0727","SA21: Transfers and Grants made by the Municipality","Rate completeness of table on scale from 0 to 3","MBRR (Schedule A) r. 29",null,null,"",null,null,null,null,null,null,null,null,null,2.4390243902439024E-3,0,3,0,"locked"]
[null,"0728","SA22: Summary Councillor and Staff Benefits","Rate completeness of table on scale from 0 to 3","MBRR (Schedule A) r. 29",null,null,"",null,null,null,null,null,null,null,null,null,2.4390243902439024E-3,0,3,0,"locked"]
[null,"0729","SA23: Salaries, Allowances and Benefits (political office bearers/councillors/senior managers)","Rate completeness of table on scale from 0 to 3","MBRR (Schedule A) r. 29",null,null,"",null,null,null,null,null,null,null,null,null,2.4390243902439024E-3,0,3,0,"locked"]
[null,"0730","SA24: Summary of Personnel Numbers","Rate completeness of table on scale from 0 to 3","MBRR (Schedule A) r. 29",null,null,"",null,null,null,null,null,null,null,null,null,2.4390243902439024E-3,0,3,0]
[null,"0731","SA25: Budgeted Monthly Revenue and Expenditure","Rate completeness of table on scale from 0 to 3","MBRR (Schedule A) r. 29",null,null,"",null,null,null,null,null,null,null,null,null,2.4390243902439024E-3,0,3,0]
[null,"0732","SA26: Budgeted Monthly Revenue and Expenditure (Municipal Vote)","Rate completeness of table on scale from 0 to 3","MBRR (Schedule A) r. 29",null,null,"",null,null,null,null,null,null,null,null,null,2.4390243902439024E-3,0,3,0]
[null,"0733","SA27: Budgeted Monthly Revenue and Expenditure (Standard Classification)","Rate completeness of table on scale from 0 to 3","MBRR (Schedule A) r. 29",null,null,"",null,null,null,null,null,null,null,null,null,2.4390243902439024E-3,0,3,0]
[null,"0734","SA28: Budgeted Monthly Capital Expenditure (Municipal Vote)","Rate completeness of table on scale from 0 to 3","MBRR (Schedule A) r. 29",null,null,"",null,null,null,null,null,null,null,null,null,2.4390243902439024E-3,0,3,0]
[null,"0735","SA29: Budgeted Monthly Capital Expenditure (Standard Classification)","Rate completeness of table on scale from 0 to 3","MBRR (Schedule A) r. 29",null,null,"",null,null,null,null,null,null,null,null,null,2.4390243902439024E-3,0,3,0]
[null,"0736","SA30: Budgeted Monthly Cash Flow","Rate completeness of table on scale from 0 to 3","MBRR (Schedule A) r. 29",null,null,"",null,null,null,null,null,null,null,null,null,2.4390243902439024E-3,0,3,0]
[null,"0737","SA31: Aggregated entity budget","Rate completeness of table on scale from 0 to 4","MBRR (Schedule A) r. 30"]
[null,"0738","SA32: List of External Mechanisms","Rate completeness of table on scale from 0 to 3","MBRR (Schedule A) r. 29",null,null,"",null,null,null,null,null,null,null,null,null,2.4390243902439024E-3,0,3,0]
[null,"0739","SA33: Contracts having Future Budgetary Implications","Rate completeness of table on scale from 0 to 3","MBRR (Schedule A) r. 29",null,null,"",null,null,null,null,null,null,null,null,null,2.4390243902439024E-3,0,3,0]
[null,"0740","SA34a: Capital Expenditure on New Assets by Asset Class","Rate completeness of table on scale from 0 to 3","MBRR (Schedule A) r. 29",null,null,"",null,null,null,null,null,null,null,null,null,2.4390243902439024E-3,0,3,0]
[null,"0741","SA34b: Capital Expenditure on the Renewal of Existing Assets by Asset Class","Rate completeness of table on scale from 0 to 3","MBRR (Schedule A) r. 29",null,null,"",null,null,null,null,null,null,null,null,null,2.4390243902439024E-3,0,3,0]
[null,"0742","SA34c: Repairs and Maintenance Expenditure by Asset Class","Rate completeness of table on scale from 0 to 3","MBRR (Schedule A) r. 29",null,null,"",null,null,null,null,null,null,null,null,null,2.4390243902439024E-3,0,3,0]
[null,"0743","SA34d: Depreciation by Asset Class","Rate completeness of table on scale from 0 to 3","MBRR (Schedule A) r. 29",null,null,"",null,null,null,null,null,null,null,null,null,2.4390243902439024E-3,0,3,0]
[null,"0748","SA34e: Capital Expenditure on the Upgrading of Existing Assets by Asset Class","Rate completeness of table on scale from 0 to 3","MBRR (Schedule A) r. 29",null,null,{"$f":"IF(F100=3,\"Fully completed\",IF(F100=2,\"Substantially completed with missing information\",IF(F100=1,\"Presented but with numerous information gaps\",IF(F100=\"-\",\"Not presented\",\"\"))))","v":""},null,null,null,null,null,null,null,null,null,2.4390243902439024E-3,{"$f":"F100","v":0},3,{"$f":"IF(ISERROR((S100*R100)*100), 0, ((S100*R100)*100))","v":0}]
[null,"0744","SA35: Future Financial Implications of the Capital Budget","Rate completeness of table on scale from 0 to 3","MBRR (Schedule A) r. 29",null,null,"",null,null,null,null,null,null,null,null,null,2.4390243902439024E-3,0,3,0]
[null,"0745","SA36: Detail Capital Budget","Rate completeness of table on scale from 0 to 3","MBRR (Schedule A) r. 29",null,null,"",null,null,null,null,null,null,null,null,null,2.4390243902439024E-3,{"$f":"F102","v":0},3,0]
[null,"0746","SA37: Projects Delayed from Previous Financial Years","Rate completeness of table on scale from 0 to 3","MBRR (Schedule A) r. 29",null,null,"",null,null,null,null,null,null,null,null,null,2.4390243902439024E-3,{"$f":"F103","v":0},3,0]
[null,"0747","SA38: Detail Operational Projects","Rate completeness of table on scale from 0 to 3","MBRR (Schedule A) r. 29",null,null,{"$f":"IF(F104=3,\"Fully completed\",IF(F104=2,\"Substantially completed with missing information\",IF(F104=1,\"Presented but with numerous information gaps\",IF(F104=\"-\",\"Not presented\",\"\"))))","v":""},null,null,null,null,null,null,null,null,null,2.4390243902439024E-3,{"$f":"F104","v":0},3,{"$f":"IF(ISERROR((S104*R104)*100), 0, ((S104*R104)*100))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R61:R103)","v":0.10000000000000005},{"$f":"SUM(S61:S103)","v":0},{"$f":"SUM(T61:T103)","v":123},{"$f":"SUM(U61:U103)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R10+R14+R25+R29+R46+R60+R105","v":1},{"$f":"S10+S14+S25+S29+S46+S60+S105","v":0},{"$f":"T10+T14+T25+T29+T46+T60+T105","v":195},{"$f":"U10+U14+U25+U29+U46+U60+U105","v":0}]
[null,"Rating","Compliance assessment rating scale","Description"]
[null,3,"full compliance (table presented with all information completed)","Fully completed"]
[null,2,"partial compliance (table presented with approximately 50% of information displayed)","Substantially completed with missing information"]
[null,1,"minimal compliance (table presented with minimal information)","Presented but with numerous information gaps"]
[null,0,"non-compliance (table etc not presented)","Not presented"]
[null,"Mail to: lgdataqueries@treasury.gov.za"]